Controlling data warehouse tasks

Once the data warehouse tables have been created and the task has been generated, you can then proceed to run the data warehouse task. The data warehouse task extracts data from the landing tables, loads it into the staging tables, and finally loads the data into the data warehouse tables.

Data warehouse tasks can be run manually, scheduled to run periodically or run as part of a workflow. The section below describes how to run a data warehouse task manually. For information on scheduling data warehouse tasks or including them in a workflow, see Controlling and monitoring tasks and workflows .

To run a data warehouse task:

1. Click the Manage button in the bottom right of the Data Warehouse panel. The Manage Data Warehouse Tasks window opens.

2. If you have more than one task, in the left pane, select the task that you want to generate.

3. Click the Run toolbar button. The window switches to Monitor view and a progress bar shows the current progress in terms of percentage.

   You can stop the task at any time by clicking the Abort toolbar button. This may be necessary if you need to urgently edit the task settings due to some unforeseen development. After editing the task settings, simply click the Run button again to restart the task.

   Information note

   Aborting a task may leave the data warehouse tables in an inconsistent state. Consistency will be restored the next time the task is run.

4. When the progress reaches 100% completed, close the Manage Data Warehouse Tasks window.

Other monitoring information such as the task details (i.e. the number of rows inserted/updated) and the task log files can be accessed by clicking the Run Details and Log buttons respectively.

Once the data warehouse has been successfully loaded into the data warehouse tables, you can then proceed to the final part of the Compose workflow - defining and populating data marts. For more information, see Creating and managing data marts .